from sqlalchemy import Column, Integer, String
from config.database import Base


class PlantPlanterServices(Base):
    """
    种植主体服务统计表
    """

    __tablename__ = 'plant_planter_services'

    id = Column(Integer, primary_key=True, autoincrement=True, nullable=False, comment='记录id')
    year = Column(Integer, nullable=True, comment='数据统计年份')
    planter_id = Column(Integer, nullable=True, comment='种植主体id')
    planter_name = Column(String(255), nullable=True, comment='种植主体')
    service_month = Column(String(255), nullable=True, comment='服务月份')
    service_type = Column(String(255), nullable=True, comment='服务类型')
    service_count = Column(Integer, nullable=True, comment='服务次数')



